SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwMovimientosEntreFechas
AS
SELECT     TOP 100 PERCENT Org.CUISE, Org.Nombre AS Organizacion, CONVERT(VARCHAR(10), CM.Fecha1, 103) AS FechaAlta, PL.CUPOF, Ag.Apellido, 
                      Ag.Nombre, SR.Descripcion, CM.Movimiento, CM.Fecha1, Org.EsPrivada, MD.Descripcion AS DescripMovimiento, Ag.Documento
FROM         dbo.tb_PlazasDeMovimiento PM INNER JOIN
                      dbo.tb_ColaDeMovimientos CM ON CM.idCola = PM.idCola INNER JOIN
                      dbo.tb_SubserviciosAgentes SSA ON SSA.idSubServicio = PM.Servicio INNER JOIN
                      dbo.tb_Organizaciones Org ON Org.idOrganizaciones = CM.Organizacion INNER JOIN
                      dbo.tb_Plazas PL ON PL.idPlaza = PM.idPlaza INNER JOIN
                      dbo.tb_Agentes Ag ON Ag.idAgente = CM.Agente INNER JOIN
                      dbo.tb_SituacionRevista SR ON SR.idSituacionRevista = CM.SitRev INNER JOIN
                      dbo.tb_MovimientosDocentes MD ON MD.idMovimiento = CM.Movimiento
WHERE     (CM.Estado IN (4, 5))
ORDER BY Org.CUISE, SR.Descripcion
GO
GRANT SELECT ON  [dbo].[vwMovimientosEntreFechas] TO [Informatica]
GRANT SELECT ON  [dbo].[vwMovimientosEntreFechas] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwMovimientosEntreFechas] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vwMovimientosEntreFechas] TO [SoloVer]
GO
EXEC sp_addextendedproperty N'MS_DiagramPane1', N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1[50] 2[25] 3) )"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1 [56] 4 [18] 2))"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "PM"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 114
               Right = 234
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "CM"
            Begin Extent = 
               Top = 12
               Left = 308
               Bottom = 120
               Right = 497
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "SSA"
            Begin Extent = 
               Top = 6
               Left = 499
               Bottom = 114
               Right = 690
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Org"
            Begin Extent = 
               Top = 6
               Left = 728
               Bottom = 114
               Right = 917
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "PL"
            Begin Extent = 
               Top = 6
               Left = 955
               Bottom = 114
               Right = 1185
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Ag"
            Begin Extent = 
               Top = 171
               Left = 64
               Bottom = 279
               Right = 265
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "SR"
            Begin Extent = 
               Top = 205
               Left = 441
               Bottom = 298
               Right = 630
            End
            DisplayFlags = 280
            TopColumn = 0
        ', 'USER', N'dbo', 'VIEW', N'vwMovimientosEntreFechas', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_DiagramPane2', N' End
         Begin Table = "MD"
            Begin Extent = 
               Top = 114
               Left = 668
               Bottom = 222
               Right = 857
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      RowHeights = 220
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', 'USER', N'dbo', 'VIEW', N'vwMovimientosEntreFechas', NULL, NULL
GO
DECLARE @xp int
SELECT @xp=2
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', @xp, 'USER', N'dbo', 'VIEW', N'vwMovimientosEntreFechas', NULL, NULL
GO
